{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Traktorer","Traktorer2","Maskiner","Maskiner2","Maskiner3","Maskiner4","Vogne","Resultat","Maskinliste","Vejledning"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Traktorer","index":0,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,1,0,3],[31,4,31,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[26,4,26,5],[25,4,25,5]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til traktorer og mejetærskere"]
[null,null,null,null,null,null,null,"© kura & cha 07.06.23"]
["Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år"]
["Årligt værditab, % "]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,{"$f":"G5*(1-G7)^G6","v":0},0]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,{"$f":"IF(AND(ISNUMBER(G5),ISNUMBER(G6),ISNUMBER(G7),ISNUMBER(G8)),PMT(G8,G6,G5,-G9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(H5),ISNUMBER(H6),ISNUMBER(H7),ISNUMBER(H8)),PMT(H8,H6,H5,-H9)*-1,0)","v":0},{"$f":"SUM(B10:H10)","v":0}]
["Gns. forsikring, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0}]
["Diverse, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,{"$f":"SUM(G10:G12)","v":0},{"$f":"SUM(H10:H12)","v":0},{"$f":"SUM(B13:H13)","v":0}]
["Vedligehold, kr./time"]
["Brændstof, liter/time"]
["Brændstof, kr./time",{"$f":"B15*Resultat!$F$5","v":0},{"$f":"C15*Resultat!$F$5","v":0},{"$f":"D15*Resultat!$F$5","v":0},{"$f":"E15*Resultat!$F$5","v":0},{"$f":"F15*Resultat!$F$5","v":0},{"$f":"G15*Resultat!$F$5","v":0},{"$f":"H15*Resultat!$F$5","v":0}]
["Arbejdsløn, kr./time"]
["Stykomkostninger, kr./time",{"$f":"B14+B16+B17","v":0},0,{"$f":"D14+D16+D17","v":0},0,0,{"$f":"G14+G16+G17","v":0},0]
["Anvendelse, timer/år",null,null,null,null,null,{"$f":"IF(G23<>0,G24/G23,0)","v":207.74285714285716},{"$f":"IF(H23<>0,H24/H23,0)","v":0}]
["Fordelte traktortimer, timer/år",{"$f":"Maskiner!$L40+Maskiner2!$L40+Maskiner3!$L40+Maskiner4!$L40+Vogne!$L40","v":0},{"$f":"Maskiner!M40+Maskiner2!M40+Maskiner3!M40+Maskiner4!M40+Vogne!M40","v":0},{"$f":"Maskiner!N40+Maskiner2!N40+Maskiner3!N40+Maskiner4!N40+Vogne!N40","v":0},{"$f":"Maskiner!O40+Maskiner2!O40+Maskiner3!O40+Maskiner4!O40+Vogne!O40","v":0},{"$f":"Maskiner!P40+Maskiner2!P40+Maskiner3!P40+Maskiner4!P40+Vogne!P40","v":0}]
["Kapacitetsomkostninger, kr./time",{"$f":"IF(B19<>0,B13/B19,\"\")","v":""},{"$f":"IF(C19<>0,C13/C19,\"\")","v":""},{"$f":"IF(D19<>0,D13/D19,\"\")","v":""},{"$f":"IF(E19<>0,E13/E19,\"\")","v":""},{"$f":"IF(F19<>0,F13/F19,\"\")","v":""},{"$f":"IF(G19<>0,G13/G19,\"\")","v":0},""]
["I alt omkostning, kr./time",{"$f":"IF(B19>0,B21+B18,0)","v":0},{"$f":"IF(C19>0,C21+C18,0)","v":0},{"$f":"IF(D19>0,D21+D18,0)","v":0},{"$f":"IF(E19>0,E21+E18,0)","v":0},{"$f":"IF(F19>0,F21+F18,0)","v":0},{"$f":"IF(G19>0,G21+G18,0)","v":0},0]
[null,null,null,null,"Kapacitet mejetærsker ha/time",null,3.5]
[null,null,null,null,"Behandlet arel, ha/år",null,727.1]
[null,null,null,null,"Mejetærsker kr/ha",null,{"$f":"IF(G23<>0,G22/G23,0)","v":0},{"$f":"IF(H23<>0,H22/H23,0)","v":0}]
[null,null,null,null,"Maskinstationstakst, kr./ha"]
[null,null,null,null,"Resultat egen maskine, kr./ha",null,{"$f":"G26-G25","v":0},{"$f":"H26-H25","v":0}]
[]
[]
[]
[]
[null,null,null,null,"Timeforbrug/arbejdsopgave",null,{"$f":"G19","v":207.74285714285716},0]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B32:H32)","v":207.74285714285716},{"$f":"H33","v":207.74285714285716}]
[]
[]
["Vedligehold årligt, kr.",{"$f":"B$19*B14","v":0},{"$f":"C$19*C14","v":0},{"$f":"D$19*D14","v":0},{"$f":"E$19*E14","v":0},{"$f":"F$19*F14","v":0},{"$f":"G$19*G14","v":0},0,{"$f":"SUM(B36:H36)","v":0}]
["Brændstof årligt, kr.",{"$f":"B$19*B16","v":0},0,0,0,0,{"$f":"G$19*G16","v":0},0,0]
["Lønomkostning årligt, kr.",0,0,0,0,0,{"$f":"G$19*G17","v":0},0,{"$f":"SUM(B38:H38)","v":0}]
[]
[]
["Resultat egne maskiner",null,null,null,null,null,{"$f":"G27*G24","v":0},{"$f":"H27*H24","v":0},{"$f":"SUM(G41:H41)","v":0}]
["Ufordelte traktoromkostninger",{"$f":"(B19-B20)*-B22","v":0},{"$f":"(C19-C20)*-C22","v":0},0,0,0,null,null,{"$f":"SUM(B42:H42)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Traktorer2","index":1,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[31,4,31,5],[0,1,0,3],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til traktorer og mejetærskere"]
[]
["Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år"]
["Årligt værditab, % "]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,0,0]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,0,0,{"$f":"SUM(B10:H10)","v":0}]
["Gns. forsikring, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0}]
["Diverse, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,0,0,{"$f":"SUM(B13:H13)","v":0}]
["Vedligehold, kr./time"]
["Brændstof, liter/time"]
["Brændstof, kr./time",{"$f":"B15*Resultat!$F$5","v":0},{"$f":"C15*Resultat!$F$5","v":0},{"$f":"D15*Resultat!$F$5","v":0},{"$f":"E15*Resultat!$F$5","v":0},{"$f":"F15*Resultat!$F$5","v":0},{"$f":"G15*Resultat!$F$5","v":0},{"$f":"H15*Resultat!$F$5","v":0}]
["Arbejdsløn, kr./time"]
["Stykomkostninger, kr./time",{"$f":"B14+B16+B17","v":0},0,0,0,0,0,0]
["Anvendelse, timer/år",null,null,null,null,null,{"$f":"IF(G23<>0,G24/G23,0)","v":0},{"$f":"IF(H23<>0,H24/H23,0)","v":0}]
["Fordelte traktortimer, timer/år",{"$f":"Maskiner!Q40+Maskiner2!Q40+Maskiner3!Q40+Maskiner4!Q40+Vogne!Q40","v":0},{"$f":"Maskiner!R40+Maskiner2!R40+Maskiner3!R40+Maskiner4!R40+Vogne!R40","v":0},{"$f":"Maskiner!S40+Maskiner2!S40+Maskiner3!S40+Maskiner4!S40+Vogne!S40","v":0},{"$f":"Maskiner!T40+Maskiner2!T40+Maskiner3!T40+Maskiner4!T40+Vogne!T40","v":0},{"$f":"Maskiner!U40+Maskiner2!U40+Maskiner3!U40+Maskiner4!U40+Vogne!U40","v":0}]
["Kapacitetsomkostninger, kr./time",{"$f":"IF(B19<>0,B13/B19,\"\")","v":""},{"$f":"IF(C19<>0,C13/C19,\"\")","v":""},{"$f":"IF(D19<>0,D13/D19,\"\")","v":""},{"$f":"IF(E19<>0,E13/E19,\"\")","v":""},{"$f":"IF(F19<>0,F13/F19,\"\")","v":""},{"$f":"IF(G19<>0,G13/G19,\"\")","v":""},""]
["I alt omkostning, kr./time",{"$f":"IF(B19>0,B21+B18,0)","v":0},{"$f":"IF(C19>0,C21+C18,0)","v":0},{"$f":"IF(D19>0,D21+D18,0)","v":0},{"$f":"IF(E19>0,E21+E18,0)","v":0},{"$f":"IF(F19>0,F21+F18,0)","v":0},{"$f":"IF(G19>0,G21+G18,0)","v":0},0]
[null,null,null,null,"Kapacitet mejetærsker ha/time"]
[null,null,null,null,"Behandlet arel, ha/år"]
[null,null,null,null,"Mejetærsker kr/ha",null,{"$f":"IF(G23<>0,G22/G23,0)","v":0},{"$f":"IF(H23<>0,H22/H23,0)","v":0}]
[null,null,null,null,"Maskinstationstakst, kr./ha"]
[null,null,null,null,"Resultat egen maskine, kr./ha",null,{"$f":"G26-G25","v":0},{"$f":"H26-H25","v":0}]
[]
[]
[]
[]
[null,null,null,null,"Timeforbrug/arbejdsopgave",null,{"$f":"G19","v":0},0]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B32:H32)","v":0},{"$f":"H33","v":0}]
[]
[]
["Vedligehold årligt, kr.",{"$f":"B$19*B14","v":0},{"$f":"C$19*C14","v":0},{"$f":"D$19*D14","v":0},{"$f":"E$19*E14","v":0},{"$f":"F$19*F14","v":0},{"$f":"G$19*G14","v":0},0,{"$f":"SUM(B36:H36)","v":0}]
["Brændstof årligt, kr.",{"$f":"B$19*B16","v":0},0,0,0,0,0,0,0]
["Lønomkostning årligt, kr.",0,0,0,0,0,0,0,{"$f":"SUM(B38:H38)","v":0}]
[]
[]
["Resultat egne maskiner",null,null,null,null,null,{"$f":"G27*G24","v":0},{"$f":"H27*H24","v":0},{"$f":"SUM(G41:H41)","v":0}]
["Ufordelte traktoromkostninger",{"$f":"(B19-B20)*-B22","v":0},{"$f":"(C19-C20)*-C22","v":0},0,0,0,null,null,{"$f":"SUM(B42:H42)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Maskiner","index":2,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til markarbejde"]
[]
["Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år",null,null,null,null,null,null,null,null,1,{"$f":"Traktorer!B4","v":0},{"$f":"TRUNC(Traktorer!B22,0)","v":0}]
["Årligt værditab, % ",null,null,null,null,null,null,null,null,2,{"$f":"Traktorer!C4","v":0},{"$f":"TRUNC(Traktorer!C22,0)","v":0}]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},null,3,{"$f":"Traktorer!D4","v":0},{"$f":"TRUNC(Traktorer!D22,0)","v":0}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,{"$f":"G5*(1-G7)^G6","v":0},0,null,4,{"$f":"Traktorer!E4","v":0},{"$f":"TRUNC(Traktorer!E22,0)","v":0}]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,{"$f":"IF(AND(ISNUMBER(G5),ISNUMBER(G6),ISNUMBER(G7),ISNUMBER(G8)),PMT(G8,G6,G5,-G9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(H5),ISNUMBER(H6),ISNUMBER(H7),ISNUMBER(H8)),PMT(H8,H6,H5,-H9)*-1,0)","v":0},{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Traktorer!F4","v":0},{"$f":"TRUNC(Traktorer!F22,0)","v":0}]
["Gns. forsikring, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Traktorer2!B4","v":0},{"$f":"TRUNC(Traktorer2!B$22,0)","v":0}]
["Diverse, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Traktorer2!C4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,{"$f":"SUM(G10:G12)","v":0},{"$f":"SUM(H10:H12)","v":0},{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Traktorer2!D4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Vedligehold, kr./time",null,null,null,null,null,null,null,null,9,{"$f":"Traktorer2!E4","v":0},{"$f":"TRUNC(Traktorer2!E$22,0)","v":0}]
["Valg af traktor",null,null,null,null,null,null,null,null,10,{"$f":"Traktorer2!F4","v":0},{"$f":"TRUNC(Traktorer2!F$22,0)","v":0}]
["Traktoromkostning, kr./time",{"$f":"VLOOKUP(L22,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L23,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L24,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L25,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L26,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L27,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L28,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Traktorer2!G$22,0)","v":0}]
["Stykomkostninger, kr./time",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,0,0,0,0]
["Behandlet areal, ha/år"]
["Kapacitet, ha/time"]
["Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,0,0,0,0,null,null,null,"Database"]
["Kapacitetsomkostninger, kr./time",{"$f":"IF(SUM(B18:B19)=0,0,B13/B20)","v":0},{"$f":"IF(SUM(C18:C19)=0,0,C13/C20)","v":0},0,0,0,0,0,null,null,null,"Traktor","Timer"]
["I alt omkostning, kr./time",{"$f":"B17+B21","v":0},{"$f":"C17+C21","v":0},0,0,0,0,0,null,null,null,1,{"$f":"B30","v":0}]
["Stykomkostninger, kr./ha",{"$f":"B17/B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,3,{"$f":"C30","v":0}]
["I alt omkostning, kr./ha",{"$f":"IF(B19<>0,B22/B19,0)","v":0},{"$f":"IF(C19<>0,C22/C19,0)","v":0},0,0,0,0,0,null,null,null,3,{"$f":"D30","v":0}]
["Maskinstationstakst, kr./ha",null,null,null,null,null,null,null,null,null,null,4,{"$f":"E30","v":0}]
["Resultat egen maskine, kr./ha",{"$f":"B25-B24","v":0},{"$f":"C25-C24","v":0},0,0,0,0,0,null,null,null,1,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
["Timeforbrug/arbejdsopgave",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,0,0,0,{"$f":"IF(H20<>0,H20,0)","v":0}]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0}]
[]
[]
["Vedligehold årligt, kr.",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,0,0,0,0,{"$f":"SUM(B34:H34)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$21:$M$28,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$21:$M$28,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Resultat egne maskiner",{"$f":"B26*B18","v":0},0,0,0,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Maskiner2","index":3,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til markarbejde"]
[]
["Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,null,null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år",null,null,null,null,null,null,null,null,1,{"$f":"Traktorer!B4","v":0},{"$f":"TRUNC(Traktorer!B22,0)","v":0}]
["Årligt værditab, % ",null,null,null,null,null,null,null,null,2,{"$f":"Traktorer!C4","v":0},{"$f":"TRUNC(Traktorer!C22,0)","v":0}]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},null,3,{"$f":"Traktorer!D4","v":0},{"$f":"TRUNC(Traktorer!D22,0)","v":0}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,0,0,0,0,null,4,{"$f":"Traktorer!E4","v":0},{"$f":"TRUNC(Traktorer!E22,0)","v":0}]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,0,0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Traktorer!F4","v":0},{"$f":"TRUNC(Traktorer!F22,0)","v":0}]
["Gns. forsikring, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Traktorer2!B4","v":0},{"$f":"TRUNC(Traktorer2!B$22,0)","v":0}]
["Diverse, kr./år",null,null,null,null,null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Traktorer2!C4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Traktorer2!D4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Vedligehold, kr./time",null,null,null,null,null,null,null,null,9,{"$f":"Traktorer2!E4","v":0},{"$f":"TRUNC(Traktorer2!E$22,0)","v":0}]
["Valg af traktor",null,null,null,null,null,null,null,null,10,{"$f":"Traktorer2!F4","v":0},{"$f":"TRUNC(Traktorer2!F$22,0)","v":0}]
["Traktoromkostning, kr./time",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L33,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Traktorer2!G$22,0)","v":0}]
["Stykomkostninger, kr./time",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,0,0,0,0]
["Behandlet areal, ha/år"]
["Kapacitet, ha/time"]
["Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,0,0,0,0]
["Kapacitetsomkostninger, kr./time",{"$f":"IF(B18<>0,B13/B20,0)","v":0},{"$f":"IF(C18<>0,C13/C20,0)","v":0},0,0,0,0,0]
["I alt omkostning, kr./time",{"$f":"B17+B21","v":0},{"$f":"C17+C21","v":0},0,0,0,0,0]
["Stykomkostninger, kr./ha",{"$f":"B17/B19","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["I alt omkostning, kr./ha",{"$f":"IF(B19<>0,B22/B19,0)","v":0},{"$f":"IF(C19<>0,C22/C19,0)","v":0},0,0,0,0,0]
["Maskinstationstakst, kr./ha"]
["Resultat egen maskine, kr./ha",{"$f":"B25-B24","v":0},{"$f":"C25-C24","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Timeforbrug/arbejdsopgave",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,0,0,0,{"$f":"IF(H20<>0,H20,0)","v":0},null,null,null,5,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,11,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"E30","v":0}]
["Vedligehold årligt, kr.",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,0,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,5,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Resultat egne maskiner",{"$f":"B26*B18","v":0},0,0,0,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123,123456789123]

{"sheet":"Maskiner3","index":4,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til markarbejde (skift af enheder til stk eller tons)"]
[]
["Fabrikat/model:",null,null,null,"Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,"Maskinens handelsværdi, kr.",null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år",null,null,null,"Kalkulationsperiode, år",null,null,null,null,1,{"$f":"Traktorer!B4","v":0},{"$f":"TRUNC(Traktorer!B22,0)","v":0}]
["Årligt værditab, % ",null,null,null,"Årligt værditab, % ",null,null,null,null,2,{"$f":"Traktorer!C4","v":0},{"$f":"TRUNC(Traktorer!C22,0)","v":0}]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},"Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},null,3,{"$f":"Traktorer!D4","v":0},{"$f":"TRUNC(Traktorer!D22,0)","v":0}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,"Scrapværdi i slut år, kr. ",0,0,0,null,4,{"$f":"Traktorer!E4","v":0},{"$f":"TRUNC(Traktorer!E22,0)","v":0}]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,"Gns.kapitalomk. (GKO), kr./år",0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Traktorer!F4","v":0},{"$f":"TRUNC(Traktorer!F22,0)","v":0}]
["Gns. forsikring, kr./år",null,null,null,"Gns. forsikring, kr./år",null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Traktorer2!B4","v":0},{"$f":"TRUNC(Traktorer2!B$22,0)","v":0}]
["Diverse, kr./år",null,null,null,"Diverse, kr./år",null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Traktorer2!C4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,"Kapacitetsomkostninger, kr./år",0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Traktorer2!D4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Vedligehold, kr./time",null,null,null,"Vedligehold, kr./time",null,null,null,null,9,{"$f":"Traktorer2!E4","v":0},{"$f":"TRUNC(Traktorer2!E$22,0)","v":0}]
["Valg af traktor",null,null,null,"Valg af traktor",null,null,null,null,10,{"$f":"Traktorer2!F4","v":0},{"$f":"TRUNC(Traktorer2!F$22,0)","v":0}]
["Traktoromkostning, kr./time",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},"Traktoromkostning, kr./time",{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Traktorer2!G$22,0)","v":0}]
["Stykomkostninger, kr./time",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,"Stykomkostninger, kr./time",{"$f":"F14+F16","v":0},0,0]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,2)","v":"Stk./år i alt"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$O$26,2)","v":"Tons/år i alt"}]
[]
["Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,"Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(F19<>0,F18/F19,0)","v":0},{"$f":"IF(G19<>0,G18/G19,0)","v":0},0]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./stk."},{"$f":"IF(B18<>0,B17*B30/B18,0)","v":0},{"$f":"IF(C18<>0,C17*C30/C18,0)","v":0},{"$f":"IF(D18<>0,D17*D30/D18,0)","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(F18<>0,F17*F30/F18,0)","v":0},{"$f":"IF(G18<>0,G17*G30/G18,0)","v":0},{"$f":"IF(H18<>0,H17*H30/H18,0)","v":0}]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./stk"},{"$f":"IF(B18<>0,B13/B18,0)","v":0},{"$f":"IF(C18<>0,C13/C18,0)","v":0},0,{"$f":"VLOOKUP($K$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(F18<>0,F13/F18,0)","v":0},{"$f":"IF(G18<>0,G13/G18,0)","v":0},0,null,2,1]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./stk"},{"$f":"B21+B22","v":0},0,{"$f":"D21+D22","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ton"},{"$f":"F21+F22","v":0},0,0,null,1,2,3,4,5,6,7,8,9]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./stk"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,null,1,"Tons/år i alt","Kapacitet, ton/time","Stykomkostninger, kr./ton","Kapacitetsomkostninger, kr./ton","I alt omkostning, kr./ton","Maskinstationstakst, kr./ton","Resultat egen maskine, kr./ton","ton"]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./stk"},{"$f":"B24-B23","v":0},{"$f":"C24-C23","v":0},{"$f":"D24-D23","v":0},{"$f":"VLOOKUP($K$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"F24-F23","v":0},{"$f":"G24-G23","v":0},{"$f":"H24-H23","v":0},null,2,"Stk./år i alt","Kapacitet, stk./time","Stykomkostninger, kr./stk.","Kapacitetsomkostninger, kr./stk","I alt omkostning, kr./stk","Maskinstationstakst, kr./stk","Resultat egen maskine, kr./stk","stk."]
[null,null,null,null,null,null,null,null,null,3,"Ha/år i alt","Kapacitet, ha/time","Stykomkostninger, kr./ha","Kapacitetsomkostninger, kr./ha","I alt omkostning, kr./ha","Maskinstationstakst, kr./ha","Resultat egen maskine, kr./ha","time"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Timeforbrug/arbejdsopgave",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,null,{"$f":"IF(F20<>0,F20,0)","v":0},0,0,null,null,null,11,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,6,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Vedligehold årligt, kr.",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,null,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,1,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Resultat egne maskiner",{"$f":"B25*B18","v":0},{"$f":"C25*C18","v":0},0,null,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]

{"sheet":"Maskiner4","index":5,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til markarbejde (skift af enheder til stk eller tons)"]
[]
["Fabrikat/model:",null,null,null,"Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,"Maskinens handelsværdi, kr.",null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år",null,null,null,"Kalkulationsperiode, år",null,null,null,null,1,{"$f":"Traktorer!B4","v":0},{"$f":"TRUNC(Traktorer!B22,0)","v":0}]
["Årligt værditab, % ",null,null,null,"Årligt værditab, % ",null,null,null,null,2,{"$f":"Traktorer!C4","v":0},{"$f":"TRUNC(Traktorer!C22,0)","v":0}]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},"Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},null,3,{"$f":"Traktorer!D4","v":0},{"$f":"TRUNC(Traktorer!D22,0)","v":0}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,"Scrapværdi i slut år, kr. ",0,0,0,null,4,{"$f":"Traktorer!E4","v":0},{"$f":"TRUNC(Traktorer!E22,0)","v":0}]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,"Gns.kapitalomk. (GKO), kr./år",0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Traktorer!F4","v":0},{"$f":"TRUNC(Traktorer!F22,0)","v":0}]
["Gns. forsikring, kr./år",null,null,null,"Gns. forsikring, kr./år",null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Traktorer2!B4","v":0},{"$f":"TRUNC(Traktorer2!B$22,0)","v":0}]
["Diverse, kr./år",null,null,null,"Diverse, kr./år",null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Traktorer2!C4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,"Kapacitetsomkostninger, kr./år",0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Traktorer2!D4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Vedligehold, kr./time",null,null,null,"Vedligehold, kr./time",null,null,null,null,9,{"$f":"Traktorer2!E4","v":0},{"$f":"TRUNC(Traktorer2!E$22,0)","v":0}]
["Valg af traktor",null,null,null,"Valg af traktor",null,null,null,null,10,{"$f":"Traktorer2!F4","v":0},{"$f":"TRUNC(Traktorer2!F$22,0)","v":0}]
["Traktoromkostning, kr./time",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},"Traktoromkostning, kr./time",{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Traktorer2!G$22,0)","v":0}]
["Stykomkostninger, kr./time",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,"Stykomkostninger, kr./time",{"$f":"F14+F16","v":0},0,0]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,2)","v":"Ha/år i alt"},null,null,null,{"$f":"VLOOKUP($K$22,$J$24:$O$26,2)","v":"Ha/år i alt"}]
[]
["Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},0,"Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(F19<>0,F18/F19,0)","v":0},{"$f":"IF(G19<>0,G18/G19,0)","v":0},0,null,null,2]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ha"},{"$f":"IF(B18<>0,B17*B30/B18,0)","v":0},{"$f":"IF(C18<>0,C17*C30/C18,0)","v":0},{"$f":"IF(D18<>0,D17*D30/D18,0)","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,4)","v":"Stykomkostninger, kr./ha"},{"$f":"IF(F18<>0,F17*F30/F18,0)","v":0},{"$f":"IF(G18<>0,G17*G30/G18,0)","v":0},{"$f":"IF(H18<>0,H17*H30/H18,0)","v":0}]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ha"},{"$f":"IF(B18<>0,B13/B18,0)","v":0},{"$f":"IF(C18<>0,C13/C18,0)","v":0},0,{"$f":"VLOOKUP($K$22,$J$24:$O$26,5)","v":"Kapacitetsomkostninger, kr./ha"},{"$f":"IF(F18<>0,F13/F18,0)","v":0},{"$f":"IF(G18<>0,G13/G18,0)","v":0},0,null,3,3]
[{"$f":"VLOOKUP($J$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ha"},{"$f":"B21+B22","v":0},0,{"$f":"D21+D22","v":0},{"$f":"VLOOKUP($K$22,$J$24:$O$26,6)","v":"I alt omkostning, kr./ha"},{"$f":"F21+F22","v":0},0,0,null,1,2,3,4,5,6,7,8,9]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ha"},600,600,1500,{"$f":"VLOOKUP($K$22,$J$24:$Q$26,7)","v":"Maskinstationstakst, kr./ha"},15,9,22,null,1,"Tons/år i alt","Kapacitet, ton/time","Stykomkostninger, kr./ton","Kapacitetsomkostninger, kr./ton","I alt omkostning, kr./ton","Maskinstationstakst, kr./ton","Resultat egen maskine, kr./ton","ton"]
[{"$f":"VLOOKUP($J$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ha"},{"$f":"B24-B23","v":600},{"$f":"C24-C23","v":600},{"$f":"D24-D23","v":1500},{"$f":"VLOOKUP($K$22,$J$24:$Q$26,8)","v":"Resultat egen maskine, kr./ha"},{"$f":"F24-F23","v":15},{"$f":"G24-G23","v":9},{"$f":"H24-H23","v":22},null,2,"Stk./år i alt","Kapacitet, stk./time","Stykomkostninger, kr./stk.","Kapacitetsomkostninger, kr./stk","I alt omkostning, kr./stk","Maskinstationstakst, kr./stk","Resultat egen maskine, kr./stk","stk."]
[null,null,null,null,null,null,null,null,null,3,"Ha/år i alt","Kapacitet, ha/time","Stykomkostninger, kr./ha","Kapacitetsomkostninger, kr./ha","I alt omkostning, kr./ha","Maskinstationstakst, kr./ha","Resultat egen maskine, kr./ha","time"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Timeforbrug/arbejdsopgave",{"$f":"IF(B20<>0,B20,0)","v":0},0,0,null,{"$f":"IF(F20<>0,F20,0)","v":0},0,0,null,null,null,2,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,1,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Vedligehold årligt, kr.",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,null,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,1,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[]
[]
["Resultat egne maskiner",{"$f":"B25*B18","v":0},{"$f":"C25*C18","v":0},0,null,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]

{"sheet":"Vogne","index":6,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
["Ejendom:",{"$f":"Resultat!F1","v":0},null,null,null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
["Omkostninger til vogne"]
[]
["Fabrikat/model:",null,null,null,"Fabrikat/model:"]
["Maskinens handelsværdi, kr.",null,null,null,"Maskinens handelsværdi, kr.",null,null,null,{"$f":"SUM(B5:H5)","v":0}]
["Kalkulationsperiode, år",null,null,null,"Kalkulationsperiode, år",null,null,null,null,1,{"$f":"Traktorer!B4","v":0},{"$f":"TRUNC(Traktorer!B22,0)","v":0}]
["Årligt værditab, % ",null,null,null,"Årligt værditab, % ",null,null,null,null,2,{"$f":"Traktorer!C4","v":0},{"$f":"TRUNC(Traktorer!C22,0)","v":0}]
["Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},"Kalkulationsrente, % ",{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},{"$f":"Resultat!$F$3","v":0.05},null,3,{"$f":"Traktorer!D4","v":0},{"$f":"TRUNC(Traktorer!D22,0)","v":0}]
["Scrapværdi i slut år, kr. ",{"$f":"B5*(1-B7)^B6","v":0},{"$f":"C5*(1-C7)^C6","v":0},0,"Scrapværdi i slut år, kr. ",0,0,0,null,4,{"$f":"Traktorer!E4","v":0},{"$f":"TRUNC(Traktorer!E22,0)","v":0}]
["Gns.kapitalomk. (GKO), kr./år",{"$f":"IF(AND(ISNUMBER(B5),ISNUMBER(B6),ISNUMBER(B7),ISNUMBER(B8)),PMT(B8,B6,B5,-B9)*-1,0)","v":0},{"$f":"IF(AND(ISNUMBER(C5),ISNUMBER(C6),ISNUMBER(C7),ISNUMBER(C8)),PMT(C8,C6,C5,-C9)*-1,0)","v":0},0,"Gns.kapitalomk. (GKO), kr./år",0,0,0,{"$f":"SUM(B10:H10)","v":0},5,{"$f":"Traktorer!F4","v":0},{"$f":"TRUNC(Traktorer!F22,0)","v":0}]
["Gns. forsikring, kr./år",null,null,null,"Gns. forsikring, kr./år",null,null,null,{"$f":"SUM(B11:H11)","v":0},6,{"$f":"Traktorer2!B4","v":0},{"$f":"TRUNC(Traktorer2!B$22,0)","v":0}]
["Diverse, kr./år",null,null,null,"Diverse, kr./år",null,null,null,{"$f":"SUM(B12:H12)","v":0},7,{"$f":"Traktorer2!C4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Kapacitetsomkostninger, kr./år",{"$f":"SUM(B10:B12)","v":0},{"$f":"SUM(C10:C12)","v":0},0,"Kapacitetsomkostninger, kr./år",0,0,0,{"$f":"SUM(B13:H13)","v":0},8,{"$f":"Traktorer2!D4","v":0},{"$f":"TRUNC(Traktorer2!C$22,0)","v":0}]
["Vedligehold, kr./time",null,null,null,"Vedligehold, kr./time",null,null,null,null,9,{"$f":"Traktorer2!E4","v":0},{"$f":"TRUNC(Traktorer2!E$22,0)","v":0}]
["Valg af traktor",null,null,null,"Valg af traktor",null,null,null,null,10,{"$f":"Traktorer2!F4","v":0},{"$f":"TRUNC(Traktorer2!F$22,0)","v":0}]
["Traktoromkostning, kr./time",{"$f":"VLOOKUP(L30,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L31,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L32,$J$6:$L$16,3)","v":0},"Traktoromkostning, kr./time",{"$f":"VLOOKUP(L34,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L35,$J$6:$L$16,3)","v":0},{"$f":"VLOOKUP(L36,$J$6:$L$16,3)","v":0},null,11,"(ingen traktor)",{"$f":"TRUNC(Traktorer2!G$22,0)","v":0}]
["Stykomkostninger, kr./time",{"$f":"B14+B16","v":0},{"$f":"C14+C16","v":0},0,"Stykomkostninger, kr./time",{"$f":"F14+F16","v":0},0,0]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,2)","v":"Tons/år i alt"},null,null,null,{"$f":"VLOOKUP($K$20,$J$22:$O$24,2)","v":"Tons/år i alt"}]
[]
["Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},{"$f":"IF(D19<>0,D18/D19,0)","v":0},"Timeforbrug/arbejdsopgave, timer/år",{"$f":"IF(F19<>0,F18/F19,0)","v":0},0,0,null,1,1]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(B18<>0,B17*B30/B18,0)","v":0},{"$f":"IF(C18<>0,C17*C30/C18,0)","v":0},{"$f":"IF(D18<>0,D17*D30/D18,0)","v":0},{"$f":"VLOOKUP($K$20,$J$22:$O$25,4)","v":"Stykomkostninger, kr./ton"},{"$f":"IF(F18<>0,F17*F30/F18,0)","v":0},{"$f":"IF(G18<>0,G17*G30/G18,0)","v":0},{"$f":"IF(H18<>0,H17*H30/H18,0)","v":0},null,1,2,3,4,5,6,7,8,9]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(B18<>0,B13/B18,0)","v":0},{"$f":"IF(C18<>0,C13/C18,0)","v":0},{"$f":"IF(D18<>0,D13/D18,0)","v":0},{"$f":"VLOOKUP($K$20,$J$22:$O$25,5)","v":"Kapacitetsomkostninger, kr./ton"},{"$f":"IF(F18<>0,F13/F18,0)","v":0},{"$f":"IF(G18<>0,G13/G18,0)","v":0},{"$f":"IF(H18<>0,H13/H18,0)","v":0},null,1,"Tons/år i alt","Kapacitet, ton/time","Stykomkostninger, kr./ton","Kapacitetsomkostninger, kr./ton","I alt omkostning, kr./ton","Maskinstationstakst, kr./ton","Resultat egen maskine, kr./ton","ton"]
[{"$f":"VLOOKUP($J$20,$J$22:$O$24,6)","v":"I alt omkostning, kr./ton"},{"$f":"B21+B22","v":0},{"$f":"C21+C22","v":0},{"$f":"D21+D22","v":0},{"$f":"VLOOKUP($K$20,$J$22:$O$25,6)","v":"I alt omkostning, kr./ton"},{"$f":"F21+F22","v":0},0,0,null,2,"Stk./år i alt","Kapacitet, stk./time","Stykomkostninger, kr./stk.","Kapacitetsomkostninger, kr./stk","I alt omkostning, kr./stk","Maskinstationstakst, kr./stk","Resultat egen maskine, kr./stk","stk."]
[{"$f":"VLOOKUP($J$20,$J$22:$Q$24,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,{"$f":"VLOOKUP($K$20,$J$22:$Q$25,7)","v":"Maskinstationstakst, kr./ton"},null,null,null,null,3,"Timer/år i alt","Kapacitet, time/time","Stykomkostninger, kr./time","Kapacitetsomkostninger, kr./time","I alt omkostning, kr./time","Maskinstationstakst, kr./time","Resultat egen maskine, kr./time","time"]
[{"$f":"VLOOKUP($J$20,$J$22:$Q$24,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"B24-B23","v":0},{"$f":"C24-C23","v":0},{"$f":"D24-D23","v":0},{"$f":"VLOOKUP($K$20,$J$22:$Q$25,8)","v":"Resultat egen maskine, kr./ton"},{"$f":"F24-F23","v":0},{"$f":"G24-G23","v":0},{"$f":"H24-H23","v":0},{"$f":"SUM(B25:H25)","v":0},4,"Ha/år i alt","Kapacitet, ha/time","Stykomokostninger, kr./ha","Kapacitetsomkostninger, kr./ha","I alt omkostning, kr./ha","Maskinstationstakst, kr./ha","Resultat egen maskine, kr./ha","time"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Database"]
[null,null,null,null,null,null,null,null,null,null,null,"Traktor","Timer"]
["Timeforbrug/arbejdsopgave",{"$f":"IF(B16<>0,B18/IF(B19>0,B19,1),0)","v":0},{"$f":"IF(C16<>0,C18/IF(C19>0,C19,1),0)","v":0},{"$f":"IF(D16<>0,D18/IF(D19>0,D19,1),0)","v":0},null,{"$f":"IF(F16<>0,F18/IF(F19>0,F19,1),0)","v":0},{"$f":"IF(G16<>0,G18/IF(G19>0,G19,1),0)","v":0},{"$f":"IF(H16<>0,H18/IF(H19>0,H19,1),0)","v":0},null,null,null,5,{"$f":"B30","v":0}]
[null,null,null,null,null,null,"I alt timer/år  =",{"$f":"SUM(B30:H30)","v":0},{"$f":"H31","v":0},null,null,1,{"$f":"C30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Vedligehold årligt, kr.",{"$f":"B14*B30","v":0},{"$f":"C14*C30","v":0},0,null,0,0,0,{"$f":"SUM(B34:H34)","v":0},null,null,11,{"$f":"F30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"H30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Kriterie","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor","Traktor"]
[null,null,null,null,null,null,null,null,null,null,"Traktor",1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,"Sumtimer",{"$f":"DSUM($L$29:$M$36,\"Timer\",L38:L39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",M38:M39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",N38:N39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",O38:O39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",P38:P39)","v":0},{"$f":"DSUM($L$29:$M$36,\"Timer\",Q38:Q39)","v":0},0,0,0,0]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]
[]
["Resultat egne maskiner",{"$f":"B25*B18","v":0},{"$f":"C25*C18","v":0},0,null,0,0,0,{"$f":"SUM(B43:H43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,123456789123,123456789123,123456789123,null,123456789123,123456789123,123456789123]

{"sheet":"Resultat","index":7,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":false,"merged":[[20,5,21,5],[41,7,42,7],[41,8,42,8],[35,7,36,7],[35,8,36,8],[37,7,38,7],[37,8,38,8],[39,7,40,7],[39,8,40,8],[29,7,30,7],[29,8,30,8],[31,7,32,7],[31,8,32,8],[33,7,34,7],[33,8,34,8],[23,7,24,7],[23,8,24,8],[25,7,26,7],[25,8,26,8],[27,7,28,7],[27,8,28,8],[17,7,18,7],[17,8,18,8],[19,7,20,7],[19,8,20,8],[21,7,22,7],[21,8,22,8],[11,7,12,7],[11,8,12,8],[13,7,14,7],[13,8,14,8],[15,7,16,7],[15,8,16,8],[1,3,1,4],[2,3,2,4],[4,3,4,4],[9,7,10,7],[9,8,10,8]]}
["Ejendomsoplysninger og nøgletal",null,null,null,"Ejendom:"]
[null,null,null,"Dyrket areal, ha"]
[null,null,null,"Kalkulationsrente",null,0.05]
[null,null,null,null,"År: ",2023]
[null,null,null,"Brændstof, kr./liter",null,5.88]
[]
[]
["Kr.",null,null,"I alt kr./år","Gns. kr./ha","Årsrapport",null,"Vejledende procenter for årligt værditab                                                         (fra teknikrådgiver Karl Jørgen Nielsen februar 2013)","Skønnet årlig værditab"]
["Maskinsaldo, primo, kr.",null,null,{"$f":"Vogne!I5+Maskiner4!I5+Maskiner3!I5+Maskiner2!I5+Maskiner!I5+Traktorer!I5+Traktorer2!I5","v":0},{"$f":"IF(ISNUMBER($F$2),D9/$F$2,0)","v":0},null,null,"Simple maskiner (uden teknologiudvikling) og uden motorer og som ikke er PTO drevne",12]
["Maskinstationsindtægt, kr.",null,null,{"$f":"F10","v":0},{"$f":"IF(ISNUMBER($F$2),D10/$F$2,0)","v":0},null,null,"Helt nye traktorer, med stor årlig anvendelse over (1000timer om året).",15]
["Maskinstationsudgift, kr.",null,null,{"$f":"F11","v":0},{"$f":"IF(ISNUMBER($F$2),D11/$F$2,0)","v":0}]
[null,null,null,null,null,null,null,"Helt nye traktorer, med lille årlig anvendelse under 1000timer om året",12]
["Timer",null,null,"I alt timer/år","Gns. timer/ha"]
["Timer til markarbejde",null,null,{"$f":"Vogne!I31+Maskiner4!I31+Maskiner3!I31+Maskiner2!I31+Maskiner!I31+Traktorer!I33+Traktorer2!I33","v":207.74285714285716},{"$f":"IF(ISNUMBER($F$2),D14/$F$2,0)","v":0},null,null,"Ældre traktorer, med stor årlig anvendelse over 1000timer om året",17,null,null,null,null,null,null,null,null,"Egne maskinomkostninger pr. ha, Data til lagkage"]
["Timer til vedligehold på eget værksted",null,null,null,{"$f":"IF(ISNUMBER($F$2),D15/$F$2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Arbejdsløn pr. ha",{"$f":"E21+E22","v":0}]
["Timer i alt mark, transport og vedligehold",null,null,{"$f":"SUM(D14:D15)","v":207.74285714285716},{"$f":"IF(ISNUMBER($F$2),D16/$F$2,0)","v":0},null,null,"Ældre traktorer, med lille årlig anvendelse over 1000 timer om året",14,null,null,null,null,null,null,null,null,"Stykomkostninger excl. løn pr. ha",{"$f":"E19+E20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kapacitetsomkostninger pr. ha",{"$f":"E27","v":0}]
["Maskinomkostninger",null,null,"I alt kr./år","Gns. kr./ha","Årsrapport",null,"Helt nye mejetærsker og pressere med stor årlig anvendelse over 200 ha om året"," 11-13"]
["Vedligehold, kr.",null,null,{"$f":"R19","v":0},{"$f":"IF(ISNUMBER($F$2),D19/$F$2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vogne!I34+Maskiner4!I34+Maskiner3!I34+Maskiner2!I34+Maskiner!I34+Traktorer!I36+Traktorer2!I36","v":0},"Vedligehold årligt, kr."]
["Brændstof, kr.",null,null,{"$f":"R20","v":0},0,null,null,"Helt nye mejetærsker og pressere med lille årlig anvendelse under 200 ha om året"," 9-11",null,null,null,null,null,null,null,null,{"$f":"Vogne!I35+Maskiner4!I35+Maskiner3!I35+Maskiner2!I35+Maskiner!I35+Traktorer!I37+Traktorer2!I37","v":0},"Brændstof årligt, kr."]
["Arbejdsløn traktor og mejetærsker, kr.",null,null,{"$f":"R21","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Traktorer!I38+Traktorer2!I38","v":0},"Lønomkostning årligt, kr."]
["Arbejdsløn, vedligehold                 timeløn:",null,null,{"$f":"D15*B22","v":0},0,null,null,"Ældre mejetærskere og pressere med stor årlig anvendelse over 200 ha om året","13-15"]
["Stykomkostninger, kr.",null,null,{"$f":"SUM(D19:D22)","v":0},0]
["Forsikring, kr.",null,null,{"$f":"R24","v":0},0,null,null,"Ældre mejetærsker og pressere med lille årlig anvendelse under 200 ha om året"," 12-13",null,null,null,null,null,null,null,null,{"$f":"Vogne!I11+Maskiner4!I11+Maskiner3!I11+Maskiner2!I11+Maskiner!I11+Traktorer!I11+Traktorer2!I11","v":0},"Forsikringer"]
["Diverse mv, kr.",null,null,{"$f":"R25","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Vogne!I12+Maskiner4!I12+Maskiner3!I12+Maskiner2!I12+Maskiner!I12+Traktorer!I12+Traktorer2!I12","v":0},"Diverse"]
["Værditab og forrentning (GKO), kr.",null,null,{"$f":"R26","v":0},0,null,null,"Helt ny selvkørende sprøjte med stor årlig anvendelse over 1000 ha om året"," 12-15",null,null,null,null,null,null,null,null,{"$f":"Vogne!I13+Maskiner4!I13+Maskiner3!I13+Maskiner2!I13+Maskiner!I13+Traktorer!I13+Traktorer2!I13","v":0},"GKO i alt"]
["Kapacitetsomkostninger i alt, kr.",null,null,{"$f":"SUM(D24:D26)","v":0},{"$f":"IF(ISNUMBER($F$2),ROUND(D27/$F$2,0),0)","v":0}]
["Netto maskinstation, kr.",null,null,{"$f":"(D10-D11)*-1","v":0},0,null,null,"Helt ny selvkørende sprøjte med lille  årlig anvendelse under 1000 ha om året"," 10-12"]
["Maskinomkostninger i alt, kr. med løn",null,null,{"$f":"D23+D27+D28","v":0},0]
["Maskinomkostninger i alt, kr. uden løn",null,null,{"$f":"D29-D21-D22","v":0},0,null,null,"Ældre selvkørende sprøjte med stor årlig anvendelse over 1000 ha om året","15-18"]
[]
["Maskinhus resultat",null,null,"I alt kr./år",null,null,null,"Ældre selvkørende sprøjte med lille årlig anvendelse under 1000 ha om året"," 12-14"]
["Resultat egne maskiner, kr. i alt/år",null,null,{"$f":"Vogne!I43+Maskiner4!I43+Maskiner3!I43+Maskiner2!I43+Maskiner!I43+Traktorer!I41+Traktorer2!I41","v":0}]
["Arbejdsløn, vedligehold, kr. i alt/år",null,null,{"$f":"D22*-1","v":0},null,null,null,"Almindelig trailer sprøjte med stor årlig anvendelse over 1000ha"," 12-14"]
["Ufordelte traktoromkostninger, kr. i alt/år",null,null,{"$f":"Traktorer!I42+Traktorer2!I42","v":0}]
["Resultat maskinhus, kr. i alt/år",null,null,{"$f":"SUM(D33:D35)","v":0},null,null,null,"Almindelige trailer sprøjte med lille årlig anvendelse under 1000ha"," 10-12"]
[]
[null,null,null,null,null,null,null,"Simple maskiner som plov og harver",12]
[]
[null,null,null,null,null,null,null,"Rotorsåsæt",12]
[]
[null,null,null,null,null,null,null,"Kombisåsæt",12]
[]
[null,null,null,null,null,null,null,"Vogne til halm og korn mv","8 eller 10"]
[null,null,null,null,null,null,null,"Gylleudstyr",15]
[]
[]
[]
[]
[]
[]
[]
[]
["Kommentarer:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1234,12,123456789123,123456789123,123456789123]

{"sheet":"Maskinliste","index":8,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["Maskinliste",null,null,"År: ",{"$f":"Resultat!F4","v":2023}]
[{"$f":"Resultat!F1","v":0}]
[]
[]
["Traktor","Handelsværdi, kr.","Årligt værditab, % ","Anvendelse, timer/år","I alt omkostning, kr./time"]
[{"$f":"Traktorer!B$4","v":0},{"$f":"Traktorer!B$5","v":0},{"$f":"Traktorer!B$7","v":0},{"$f":"Traktorer!B$19","v":0},{"$f":"Traktorer!B$22","v":0}]
[{"$f":"Traktorer!C$4","v":0},{"$f":"Traktorer!C$5","v":0},{"$f":"Traktorer!C$7","v":0},{"$f":"Traktorer!C$19","v":0},{"$f":"Traktorer!C$22","v":0}]
[{"$f":"Traktorer!D$4","v":0},{"$f":"Traktorer!D$5","v":0},{"$f":"Traktorer!D$7","v":0},{"$f":"Traktorer!D$19","v":0},{"$f":"Traktorer!D$22","v":0}]
[{"$f":"Traktorer!E$4","v":0},{"$f":"Traktorer!E$5","v":0},{"$f":"Traktorer!E$7","v":0},{"$f":"Traktorer!E$19","v":0},{"$f":"Traktorer!E$22","v":0}]
[{"$f":"Traktorer!F$4","v":0},{"$f":"Traktorer!F$5","v":0},{"$f":"Traktorer!F$7","v":0},{"$f":"Traktorer!F$19","v":0},{"$f":"Traktorer!F$22","v":0}]
[{"$f":"Traktorer2!B$4","v":0},{"$f":"Traktorer2!B$5","v":0},{"$f":"Traktorer2!B$7","v":0},{"$f":"Traktorer2!B$19","v":0},{"$f":"Traktorer2!B$22","v":0}]
[{"$f":"Traktorer2!C$4","v":0},{"$f":"Traktorer2!C$5","v":0},{"$f":"Traktorer2!C$7","v":0},{"$f":"Traktorer2!C$19","v":0},{"$f":"Traktorer2!C$22","v":0}]
[{"$f":"Traktorer2!D$4","v":0},{"$f":"Traktorer2!D$5","v":0},{"$f":"Traktorer2!D$7","v":0},{"$f":"Traktorer2!D$19","v":0},{"$f":"Traktorer2!D$22","v":0}]
[{"$f":"Traktorer2!E$4","v":0},{"$f":"Traktorer2!E$5","v":0},{"$f":"Traktorer2!E$7","v":0},{"$f":"Traktorer2!E$19","v":0},{"$f":"Traktorer2!E$22","v":0}]
[{"$f":"Traktorer2!F$4","v":0},{"$f":"Traktorer2!F$5","v":0},{"$f":"Traktorer2!F$7","v":0},{"$f":"Traktorer2!F$19","v":0},{"$f":"Traktorer2!F$22","v":0}]
["Mejetærsker","Handelsværdi, kr.","Årligt værditab, % ","Anvendelse, ha/år","I alt omkostning, kr./ha"]
[{"$f":"Traktorer!G$4","v":0},{"$f":"Traktorer!G$5","v":0},{"$f":"Traktorer!G$7","v":0},{"$f":"Traktorer!G$24","v":727.1},{"$f":"Traktorer!G$25","v":0}]
[{"$f":"Traktorer!H$4","v":0},{"$f":"Traktorer!H$5","v":0},{"$f":"Traktorer!H$7","v":0},{"$f":"Traktorer!H$24","v":0},{"$f":"Traktorer!H$25","v":0}]
[{"$f":"Traktorer2!G$4","v":0},{"$f":"Traktorer2!G$5","v":0},{"$f":"Traktorer2!G$7","v":0},{"$f":"Traktorer2!G$24","v":0},{"$f":"Traktorer2!G$25","v":0}]
[{"$f":"Traktorer2!H$4","v":0},{"$f":"Traktorer2!H$5","v":0},{"$f":"Traktorer2!H$7","v":0},{"$f":"Traktorer2!H$24","v":0},{"$f":"Traktorer2!H$25","v":0}]
["Maskiner","Handelsværdi, kr.","Årligt værditab, % ","Anvendelse, ha/år","I alt omkostning, kr./ha"]
[{"$f":"Maskiner!B$4","v":0},{"$f":"Maskiner!B$5","v":0},{"$f":"Maskiner!B$7","v":0},{"$f":"Maskiner!B$18","v":0},{"$f":"Maskiner!B$24","v":0}]
[{"$f":"Maskiner!C$4","v":0},{"$f":"Maskiner!C$5","v":0},{"$f":"Maskiner!C$7","v":0},{"$f":"Maskiner!C$18","v":0},{"$f":"Maskiner!C$24","v":0}]
[{"$f":"Maskiner!D$4","v":0},{"$f":"Maskiner!D$5","v":0},{"$f":"Maskiner!D$7","v":0},{"$f":"Maskiner!D$18","v":0},{"$f":"Maskiner!D$24","v":0}]
[{"$f":"Maskiner!E$4","v":0},{"$f":"Maskiner!E$5","v":0},{"$f":"Maskiner!E$7","v":0},{"$f":"Maskiner!E$18","v":0},{"$f":"Maskiner!E$24","v":0}]
[{"$f":"Maskiner!F$4","v":0},{"$f":"Maskiner!F$5","v":0},{"$f":"Maskiner!F$7","v":0},{"$f":"Maskiner!F$18","v":0},{"$f":"Maskiner!F$24","v":0}]
[{"$f":"Maskiner!G$4","v":0},{"$f":"Maskiner!G$5","v":0},{"$f":"Maskiner!G$7","v":0},{"$f":"Maskiner!G$18","v":0},{"$f":"Maskiner!G$24","v":0}]
[{"$f":"Maskiner!H$4","v":0},{"$f":"Maskiner!H$5","v":0},{"$f":"Maskiner!H$7","v":0},{"$f":"Maskiner!H$18","v":0},{"$f":"Maskiner!H$24","v":0}]
[{"$f":"Maskiner2!B$4","v":0},{"$f":"Maskiner2!B$5","v":0},{"$f":"Maskiner2!B$7","v":0},{"$f":"Maskiner2!B$18","v":0},{"$f":"Maskiner2!B$24","v":0}]
[{"$f":"Maskiner2!C$4","v":0},{"$f":"Maskiner2!C$5","v":0},{"$f":"Maskiner2!C$7","v":0},{"$f":"Maskiner2!C$18","v":0},{"$f":"Maskiner2!C$24","v":0}]
[{"$f":"Maskiner2!D$4","v":0},{"$f":"Maskiner2!D$5","v":0},{"$f":"Maskiner2!D$7","v":0},{"$f":"Maskiner2!D$18","v":0},{"$f":"Maskiner2!D$24","v":0}]
[{"$f":"Maskiner2!E$4","v":0},{"$f":"Maskiner2!E$5","v":0},{"$f":"Maskiner2!E$7","v":0},{"$f":"Maskiner2!E$18","v":0},{"$f":"Maskiner2!E$24","v":0}]
[{"$f":"Maskiner2!F$4","v":0},{"$f":"Maskiner2!F$5","v":0},{"$f":"Maskiner2!F$7","v":0},{"$f":"Maskiner2!F$18","v":0},{"$f":"Maskiner2!F$24","v":0}]
[{"$f":"Maskiner2!G$4","v":0},{"$f":"Maskiner2!G$5","v":0},{"$f":"Maskiner2!G$7","v":0},{"$f":"Maskiner2!G$18","v":0},{"$f":"Maskiner2!G$24","v":0}]
[{"$f":"Maskiner2!H$4","v":0},{"$f":"Maskiner2!H$5","v":0},{"$f":"Maskiner2!H$7","v":0},{"$f":"Maskiner2!H$18","v":0},{"$f":"Maskiner2!H$24","v":0}]
[{"$f":"Maskiner3!B$4","v":0},{"$f":"Maskiner3!B$5","v":0},{"$f":"Maskiner3!B$7","v":0},{"$f":"Maskiner3!B$18","v":0},{"$f":"Maskiner3!B$24","v":0}]
[{"$f":"Maskiner3!C$4","v":0},{"$f":"Maskiner3!C$5","v":0},{"$f":"Maskiner3!C$7","v":0},{"$f":"Maskiner3!C$18","v":0},{"$f":"Maskiner3!C$24","v":0}]
[{"$f":"Maskiner3!D$4","v":0},{"$f":"Maskiner3!D$5","v":0},{"$f":"Maskiner3!D$7","v":0},{"$f":"Maskiner3!D$18","v":0},{"$f":"Maskiner3!D$24","v":0}]
[{"$f":"Maskiner3!F$4","v":0},{"$f":"Maskiner3!F$5","v":0},{"$f":"Maskiner3!F$7","v":0},{"$f":"Maskiner3!F$18","v":0},{"$f":"Maskiner3!F$24","v":0}]
[{"$f":"Maskiner3!G$4","v":0},{"$f":"Maskiner3!G$5","v":0},{"$f":"Maskiner3!G$7","v":0},{"$f":"Maskiner3!G$18","v":0},{"$f":"Maskiner3!G$24","v":0}]
[{"$f":"Maskiner3!H$4","v":0},{"$f":"Maskiner3!H$5","v":0},{"$f":"Maskiner3!H$7","v":0},{"$f":"Maskiner3!H$18","v":0},{"$f":"Maskiner3!H$24","v":0}]
[{"$f":"Maskiner4!B$4","v":0},{"$f":"Maskiner4!B$5","v":0},{"$f":"Maskiner4!B$7","v":0},{"$f":"Maskiner4!B$18","v":0},{"$f":"Maskiner4!B$24","v":600}]
[{"$f":"Maskiner4!C$4","v":0},{"$f":"Maskiner4!C$5","v":0},{"$f":"Maskiner4!C$7","v":0},{"$f":"Maskiner4!C$18","v":0},{"$f":"Maskiner4!C$24","v":600}]
[{"$f":"Maskiner4!D$4","v":0},{"$f":"Maskiner4!D$5","v":0},{"$f":"Maskiner4!D$7","v":0},{"$f":"Maskiner4!D$18","v":0},{"$f":"Maskiner4!D$24","v":1500}]
[{"$f":"Maskiner4!F$4","v":0},{"$f":"Maskiner4!F$5","v":0},{"$f":"Maskiner4!F$7","v":0},{"$f":"Maskiner4!F$18","v":0},{"$f":"Maskiner4!F$24","v":15}]
[{"$f":"Maskiner4!G$4","v":0},{"$f":"Maskiner4!G$5","v":0},{"$f":"Maskiner4!G$7","v":0},{"$f":"Maskiner4!G$18","v":0},{"$f":"Maskiner4!G$24","v":9}]
[{"$f":"Maskiner4!H$4","v":0},{"$f":"Maskiner4!H$5","v":0},{"$f":"Maskiner4!H$7","v":0},{"$f":"Maskiner4!H$18","v":0},{"$f":"Maskiner4!H$24","v":22}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Maskiner, kr./ \"& VLOOKUP(Maskiner3!$J$22,Maskiner3!$J$23:$R$26,9)","v":"Maskiner, kr./ stk."},null,"Årligt værditab, % ",{"$f":"Maskiner3!A18","v":"Stk./år i alt"},{"$f":"\"I alt omkostning, kr./\"& VLOOKUP(Maskiner3!$J$22,Maskiner3!$J$23:$R$26,9)","v":"I alt omkostning, kr./stk."}]
[{"$f":"Maskiner3!B$4","v":0},{"$f":"Maskiner3!B$5","v":0},{"$f":"Maskiner3!B$7","v":0},{"$f":"Maskiner3!B$18","v":0},{"$f":"Maskiner3!B$23","v":0}]
[{"$f":"Maskiner3!C$4","v":0},{"$f":"Maskiner3!C$5","v":0},{"$f":"Maskiner3!C$7","v":0},{"$f":"Maskiner3!C$18","v":0},{"$f":"Maskiner3!C$23","v":0}]
[{"$f":"Maskiner3!D$4","v":0},{"$f":"Maskiner3!D$5","v":0},{"$f":"Maskiner3!D$7","v":0},{"$f":"Maskiner3!D$30","v":0},{"$f":"Maskiner3!D$23","v":0}]
[{"$f":"\"Maskiner, kr./ \"& VLOOKUP(Maskiner3!$K$22,Maskiner3!$J$23:$R$26,9)","v":"Maskiner, kr./ ton"},null,"Årligt værditab, % ",{"$f":"Maskiner3!E18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\" & VLOOKUP(Maskiner3!$K$22,Maskiner3!$J$23:$R$26,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Maskiner3!F$4","v":0},{"$f":"Maskiner3!F$5","v":0},{"$f":"Maskiner3!F$7","v":0},{"$f":"Maskiner3!F$30","v":0},{"$f":"Maskiner3!F$22","v":0}]
[{"$f":"Maskiner3!G$4","v":0},{"$f":"Maskiner3!G$5","v":0},{"$f":"Maskiner3!G$7","v":0},{"$f":"Maskiner3!G$30","v":0},{"$f":"Maskiner3!G$22","v":0}]
[{"$f":"Maskiner3!H$4","v":0},{"$f":"Maskiner3!H$5","v":0},{"$f":"Maskiner3!H$7","v":0},{"$f":"Maskiner3!H$30","v":0},{"$f":"Maskiner3!H$22","v":0}]
[{"$f":"\"Vogne, kr./\" & VLOOKUP(Vogne!$J$20,Vogne!$J$21:$R$24,9)","v":"Vogne, kr./ton"},null,"Årligt værditab, % ",{"$f":"Vogne!A18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\" & VLOOKUP(Vogne!$J$20,Vogne!$J$21:$R$24,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Vogne!B$4","v":0},{"$f":"Vogne!B$5","v":0},{"$f":"Vogne!B$7","v":0},{"$f":"Vogne!B$18","v":0},{"$f":"Vogne!B$23","v":0}]
[{"$f":"Vogne!C$4","v":0},{"$f":"Vogne!C$5","v":0},{"$f":"Vogne!C$7","v":0},{"$f":"Vogne!C$18","v":0},{"$f":"Vogne!C$23","v":0}]
[{"$f":"Vogne!D$4","v":0},{"$f":"Vogne!D$5","v":0},{"$f":"Vogne!D$7","v":0},{"$f":"Vogne!D$18","v":0},{"$f":"Vogne!D$23","v":0}]
[{"$f":"\"Vogne, kr./\" & VLOOKUP(Vogne!K$20,Vogne!$J$21:$R$24,9)","v":"Vogne, kr./ton"},null,"Årligt værditab, % ",{"$f":"Vogne!E18","v":"Tons/år i alt"},{"$f":"\"I alt omkostning, kr./\" & VLOOKUP(Vogne!K$20,Vogne!$J$21:$R$24,9)","v":"I alt omkostning, kr./ton"}]
[{"$f":"Vogne!F$4","v":0},{"$f":"Vogne!F$5","v":0},{"$f":"Vogne!F$7","v":0},{"$f":"Vogne!F$18","v":0},{"$f":"Vogne!F$23","v":0}]
[{"$f":"Vogne!G$4","v":0},{"$f":"Vogne!G$5","v":0},{"$f":"Vogne!G$7","v":0},{"$f":"Vogne!G$18","v":0},{"$f":"Vogne!G$23","v":0}]
[{"$f":"Vogne!H$4","v":0},{"$f":"Vogne!H$5","v":0},{"$f":"Vogne!H$7","v":0},{"$f":"Vogne!H$18","v":0},{"$f":"Vogne!H$23","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1234567891234,1234567891234,1234567891234,1234567891234,1234567891234]

{"sheet":"Vejledning","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}